import pandas as pd

df = pd.read_excel(r'py_excle\test.xlsx',index_col=0)

for i in range(1,6):
    df.loc[i,'C'] = df.loc[i,'A'] + df.loc[i,'B']
#print(df)
#df.to_excel(r'py_excle\test_res.xlsx')

df.loc[22,'D']=None
print(df)



